﻿CREATE TABLE [dbo].[ShipFormMaster] (
    [ShipFormNo]   VARCHAR (30)  NOT NULL,
    [ReferenceNo]  VARCHAR (30)  NOT NULL,
    [CustomerName] VARCHAR (200) NOT NULL,
    [Department]   VARCHAR (20)  NULL,
    [Warehouse]    VARCHAR (60)  NULL,
    [ShipDate]     DATETIME      NULL,
    [EntryDate]    DATETIME      NULL,
    [Author]       VARCHAR (20)  NULL,
    [Approver]     VARCHAR (20)  NULL,
    [Employee]     VARCHAR (20)  NULL,
    [Remark]       VARCHAR (100) NULL,
    [RecordId]     INT           IDENTITY (1, 1) NOT NULL
);

